Node / ReticulumProjects / MeshChatX.git / files / tests / backend / test_database_provider_boost.py

Displaying Raw • Download

T8b949e# SPDX-License-Identifier: 0BSD

Tff7b72import T7ee787sqlite3

Tff7b72import T7ee787threading

Tff7b72import T7ee787pytest

Tff7b72from T7ee787meshchatxT7ee787.T7ee787srcT7ee787.T7ee787backendT7ee787.T7ee787databaseT7ee787.T7ee787provider Tff7b72import Te6edf3DatabaseProvider

Tff7b72def Td2a8fftest_database_provider_memoryTb4b4b4(Tb4b4b4)Tb4b4b4:

Te6edf3provider Tff7b72= Te6edf3DatabaseProviderTb4b4b4(Ta5d6ff"Ta5d6ff:memory:Ta5d6ff"Tb4b4b4)

Te6edf3conn Tff7b72= Te6edf3providerTff7b72.Td2a8ffconnection

Tff7b72assert Tffa657isinstanceTb4b4b4(Te6edf3connTb4b4b4, Te6edf3sqlite3Tff7b72.Td2a8ffConnectionTb4b4b4)

Tff7b72assert Te6edf3providerTff7b72.Td2a8ffdb_path Tff7b72== Ta5d6ff"Ta5d6ff:memory:Ta5d6ff"

T8b949e# Same connection for all threads in memory mode

Tff7b72def Td2a8ffget_connTb4b4b4(Tb4b4b4)Tb4b4b4:

Tff7b72assert Te6edf3providerTff7b72.Td2a8ffconnection Tff7b72== Te6edf3conn

Te6edf3t Tff7b72= Te6edf3threadingTff7b72.Td2a8ffThreadTb4b4b4(Te6edf3targetTff7b72=Te6edf3get_connTb4b4b4)

Te6edf3tTff7b72.Td2a8ffstartTb4b4b4(Tb4b4b4)

Te6edf3tTff7b72.Td2a8ffjoinTb4b4b4(Tb4b4b4)

Tff7b72def Td2a8fftest_database_provider_executeTb4b4b4(Te6edf3tmp_pathTb4b4b4)Tb4b4b4:

Te6edf3db_file Tff7b72= Te6edf3tmp_path Tff7b72/ Ta5d6ff"Ta5d6fftest.dbTa5d6ff"

Te6edf3provider Tff7b72= Te6edf3DatabaseProviderTb4b4b4(Tffa657strTb4b4b4(Te6edf3db_fileTb4b4b4)Tb4b4b4)

Te6edf3providerTff7b72.Td2a8ffexecuteTb4b4b4(Ta5d6ff"Ta5d6ffCREATE TABLE test (id INTEGER PRIMARY KEY, val TEXT)Ta5d6ff"Tb4b4b4)

Te6edf3providerTff7b72.Td2a8ffexecuteTb4b4b4(Ta5d6ff"Ta5d6ffINSERT INTO test (val) VALUES (?)Ta5d6ff"Tb4b4b4, Tb4b4b4(Ta5d6ff"Ta5d6ffhelloTa5d6ff"Tb4b4b4,Tb4b4b4)Tb4b4b4)

Te6edf3row Tff7b72= Te6edf3providerTff7b72.Td2a8fffetchoneTb4b4b4(Ta5d6ff"Ta5d6ffSELECT val FROM testTa5d6ff"Tb4b4b4)

Tff7b72assert Te6edf3rowTb4b4b4[Ta5d6ff"Ta5d6ffvalTa5d6ff"Tb4b4b4] Tff7b72== Ta5d6ff"Ta5d6ffhelloTa5d6ff"

Tff7b72def Td2a8fftest_database_provider_transactionsTb4b4b4(Te6edf3tmp_pathTb4b4b4)Tb4b4b4:

Te6edf3db_file Tff7b72= Te6edf3tmp_path Tff7b72/ Ta5d6ff"Ta5d6fftest.dbTa5d6ff"

Te6edf3provider Tff7b72= Te6edf3DatabaseProviderTb4b4b4(Tffa657strTb4b4b4(Te6edf3db_fileTb4b4b4)Tb4b4b4)

Te6edf3providerTff7b72.Td2a8ffexecuteTb4b4b4(Ta5d6ff"Ta5d6ffCREATE TABLE test (id INTEGER PRIMARY KEY, val TEXT)Ta5d6ff"Tb4b4b4)

Te6edf3providerTff7b72.Td2a8ffbeginTb4b4b4(Tb4b4b4)

Te6edf3providerTff7b72.Td2a8ffexecuteTb4b4b4(Ta5d6ff"Ta5d6ffINSERT INTO test (val) VALUES (?)Ta5d6ff"Tb4b4b4, Tb4b4b4(Ta5d6ff"Ta5d6fftx1Ta5d6ff"Tb4b4b4,Tb4b4b4)Tb4b4b4)

Te6edf3providerTff7b72.Td2a8ffrollbackTb4b4b4(Tb4b4b4)

Tff7b72assert Te6edf3providerTff7b72.Td2a8fffetchoneTb4b4b4(Ta5d6ff"Ta5d6ffSELECT COUNT(*) as count FROM testTa5d6ff"Tb4b4b4)Tb4b4b4[Ta5d6ff"Ta5d6ffcountTa5d6ff"Tb4b4b4] Tff7b72== T79c0ff0

Te6edf3providerTff7b72.Td2a8ffbeginTb4b4b4(Tb4b4b4)

Te6edf3providerTff7b72.Td2a8ffexecuteTb4b4b4(Ta5d6ff"Ta5d6ffINSERT INTO test (val) VALUES (?)Ta5d6ff"Tb4b4b4, Tb4b4b4(Ta5d6ff"Ta5d6fftx2Ta5d6ff"Tb4b4b4,Tb4b4b4)Tb4b4b4)

Te6edf3providerTff7b72.Td2a8ffcommitTb4b4b4(Tb4b4b4)

Tff7b72assert Te6edf3providerTff7b72.Td2a8fffetchoneTb4b4b4(Ta5d6ff"Ta5d6ffSELECT COUNT(*) as count FROM testTa5d6ff"Tb4b4b4)Tb4b4b4[Ta5d6ff"Ta5d6ffcountTa5d6ff"Tb4b4b4] Tff7b72== T79c0ff1

Tff7b72def Td2a8fftest_database_provider_singletonTb4b4b4(Tb4b4b4)Tb4b4b4:

T8b949e# Reset singleton for test

Te6edf3DatabaseProviderTff7b72.Td2a8ff_instance Tff7b72= Tff7b72None

Te6edf3p1 Tff7b72= Te6edf3DatabaseProviderTff7b72.Td2a8ffget_instanceTb4b4b4(Ta5d6ff"Ta5d6ff:memory:Ta5d6ff"Tb4b4b4)

Te6edf3p2 Tff7b72= Te6edf3DatabaseProviderTff7b72.Td2a8ffget_instanceTb4b4b4(Tb4b4b4)

Tff7b72assert Te6edf3p1 Tff7b72== Te6edf3p2

Tff7b72with Te6edf3pytestTff7b72.Td2a8ffraisesTb4b4b4(Tf85149ValueErrorTb4b4b4, Te6edf3matchTff7b72=Ta5d6ff"Ta5d6ffDatabase path must be providedTa5d6ff"Tb4b4b4)Tb4b4b4:

Te6edf3DatabaseProviderTff7b72.Td2a8ff_instance Tff7b72= Tff7b72None

Te6edf3DatabaseProviderTff7b72.Td2a8ffget_instanceTb4b4b4(Tb4b4b4)